CREATE TABLE [dbo].[FS_Teacher]
(
[fdTeacLoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTeacPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTeacCollID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTeacName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTeacLoginAt] [datetime] NULL,
[fdTeacLoginIp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Teacher_fdTeacLoginIp] DEFAULT (''),
[fdTeacCreateAt] [datetime] NOT NULL CONSTRAINT [DF_FS_Teacher_fdTeacCreateAt] DEFAULT (getdate()),
[fdTeacLevel] [int] NOT NULL CONSTRAINT [DF_FS_Teacher_fdTeacLevel] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Teacher] ADD CONSTRAINT [PK_FS_Teacher] PRIMARY KEY CLUSTERED  ([fdTeacLoginID]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'学院编号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacCollID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登陆时间', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacLoginAt'
GO
EXEC sp_addextendedproperty N'MS_Description', N'老师登陆帐号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacLoginID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登陆IP', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacLoginIp'
GO
EXEC sp_addextendedproperty N'MS_Description', N'老师姓名', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'老师登陆密码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Teacher', 'COLUMN', N'fdTeacPwd'
GO
